Purpose

Keep track of status of krypto portfolio over time, based on transactions combined with current price data.

Method

  1. Log into crypto account.
  2. Download activity report.
  3. Go to spreadsheet in Marengo - check most recent transaction date there.
  4. Copy/paste new transactions from activity report.
  5. Copy down formulas in spreadsheet.

Bitcoin

date symb acb price_close diff
2021-12-04 BTC-CAD $47,796.29 $62,943.95 31.69%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

  • Cdn dollar value
  1. Get latest price data.
  2. Combine with cost data.
  3. Calculate profit and ROI.

Ethereum

date symb acb price_close diff
2021-12-04 ETH-CAD $1,649.60 $5,232.95 217.23%

Transactions & Adjusted Cost Base (Avg Cost)

Price, Costs, Profits

Cardano

date symb acb price_close diff
2021-12-04 ADA-CAD $2.64 $1.82 -31.04%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

Polkadot

date symb acb price_close diff
2021-12-04 DOT1-CAD $36.22 $37.43 3.36%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

Litecoin

date symb acb price_close diff
2021-12-04 LTC-CAD $228.96 $209.12 -8.66%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

PRICE-COST SMRY

date symb acb price_close diff
2021-12-04 BTC-CAD $47,796.29 $62,943.95 31.69%
2021-12-04 ETH-CAD $1,649.60 $5,232.95 217.23%
2021-12-04 ADA-CAD $2.64 $1.82 -31.04%
2021-12-04 DOT1-CAD $36.22 $37.43 3.36%
2021-12-04 LTC-CAD $228.96 $209.12 -8.66%

TOTALS - Returns

date currency book_val market_val profit roi
2021-12-04 BTC $3,177 $4,183 1,007 32%
2021-12-04 ETH $5,954 $18,889 12,935 217%
2021-12-04 ADA $5,801 $4,000 (1,800) -31%
2021-12-04 DOT $2,535 $2,620 85 3%
2021-12-04 LTC $2,305 $2,105 (200) -9%
date total_invested total_market_val total_profit total_roi
2021-12-04 $19,772 $31,797 $12,027 61%